www.gusucode.com > 网域标准通用企业自助建站系统正式版 2009 > 网域标准通用企业自助建站系统正式版 2009.18/网域公司企业网站管理系统ACCESS和SQL正式版/网域公司企业网站管理系统SQL正式版/EnUserOrder.asp
<!--#Include File="inc/Check_Sql.asp"--> <!--#include file="inc/conn.asp"--> <!--#include file="inc/Skin_css.asp"--> <!--#include file="inc/config.asp"--> <!--#include file="inc/Function.asp"--> <%If Session("UserName")="" Then response.redirect"EnUserServer.asp" end if%> <SCRIPT language=javascript> <!-- function chkitem(str) { var strSource ="0123456789-"; var ch; var i; var temp; for (i=0;i<=(str.length-1);i++) { ch = str.charAt(i); temp = strSource.indexOf(ch); if (temp==-1) { return 0; } } if (strSource.indexOf(ch)==-1) { return 0; } else { return 1; } } function order_onsubmit() { if (chkitem(document.order.OrderNum.value)==0) { alert("Input the correct Inquire number。"); document.order.OrderNum.focus(); return false; } } //--> </SCRIPT> <!-- #include file="EnHead.asp" --> <table width="760" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="5" valign="top" bgcolor="#FFFFFF"></td> </tr> <tr> <td height="72" valign="top" bgcolor="#FFFFFF"><table width="746" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td class="tdbg_left" width="190" height="179" valign="top" > <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="34" class="title_left"> <img src="Images/smallbook.jpg" width="10" height="10"> Member Center </td> </tr> <tr> <td height="20"> <div align="center"><a href="EnUserEdit.asp">Modify Member's info</a></div></td> </tr> <TR> <TD height=1 colspan="2" background=img/naSzarym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD> </TR> <tr> <td height="20"> <div align="center"><a href="EnUserEditPwd.asp">Modify Member's password</a></div></td> </tr> <TR> <TD height=1 colspan="2" background=img/naSzarym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD> </TR> <tr> <td height="20"> <div align="center"><a href="EnUserOrder.asp">Inquire Search</a></div></td> </tr> <TR> <TD height=1 colspan="2" background=img/naSzarym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD> </TR> <tr> <td height="20"> <div align="center"><a href="EnFeedbackMember.asp">My Feedback </a></div></td> </tr> <TR> <TD height=1 colspan="2" background=img/naSzarym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD> </TR> <tr> <td height="20"> <div align="center"><a href="UserLogout.asp?Action=En">Member Logout</a></div></td> </tr> <TR> <TD height=1 colspan="2" background=img/naSzarym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD> </TR> </table></td> <td width="6"></td> <td valign="top"><table Class=border width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="206" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="title_right" height="32"> <img src="Images/smallbook.jpg" width="10" height="10"> Member Center </td> </tr> </table> <TABLE width=98% height="136" align="center" cellPadding=4 cellSpacing=1> <TBODY> <TR vAlign=top > <TD width="100%" height="18"> <form action="Enorderofind.asp" method="post" name=order onsubmit="return order_onsubmit()" language=javascript> <p align="left" style="margin-bottom: 0"> <font color="#FF0000">Dear: </font><font size="2" face="Arial"><%=Session("UserName")%></font> <%rs.close%> <% UserName=Session("UserName") set Rs = Server.CreateObject("ADODB.recordset") sql="select * from OrderList where UserName='"&UserName&"'" rs.open sql,conn,1,1 %> </p> <p align="center" style="word-spacing: 0; margin-top: 0; margin-bottom: 0"> Inquire detailed query, please input the order number that you want to check <br> <input type="text" name="OrderNum" size="16"> <input type="submit" value="Search" name="B1"> </form> <div align="center"> <TABLE cellSpacing=0 cellPadding=0 width=100%> <TBODY> <TR> <TD align=middle width="100%"> <p align="left" style="word-spacing: 0; margin-top: 0; margin-bottom: 0">Inquire list:</p> <table border="0" cellpadding="2" cellspacing="1" width="100%" bgcolor="#000000"> <tr class='title'> <td width="26%" align="center" height="26" bgcolor="#CCCCCC">Inquire number</td> <td width="21%" align="center" height="26" bgcolor="#CCCCCC">Customer name</td> <td width="53%" align="center" height="26" bgcolor="#CCCCCC">To the process of your order</td> </tr> <% While Not rs.EOF %> <tr > <td width="26%" height="25" align="center" bgcolor="#FFFFFF"> <%response.Write " <a href='#' onclick=""javascript:window.open('EnOrderofind.asp?OrderNum=" & rs("OrderNum") &"', 'newwindow', 'height=550, width=550, toolbar=no, menubar=no, scrollbars=auto, resizable=no, location=no, status=no')"" title='" & rs("OrderNum") & "'><font color='#FF0000'>" &rs("OrderNum") & "</font></a>"%> </td> <td width="21%" align="center" height="25" bgcolor="#FFFFFF"><%=rs("Receiver")%></td> <td width="53%" align="center" height="25" bgcolor="#FFFFFF"> <%If rs("Flag")="Yes" Then%> Disposal <%else%> <font color="#FF0000"> Unsettled</font> <%End If%> </td> </tr> <% rs.MoveNext Wend rs.close %> </table> </TD> </TR> </TBODY> </TABLE> </div></TD> </TR> <TR vAlign=top > <TD width="100%" height="15"> </TD> </TR> </TBODY> </TABLE> </td> </tr> </table></td> </tr> </table></td> </tr> </table> <!-- #include file="Inc/EnFoot.asp" --> </BODY></HTML>